Stored Procedures [dbo].[BAEImisTransGetAllByTransNumber]
SQLServer > iMIS1521GA > Stored Procedures > dbo.BAEImisTransGetAllByTransNumber
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Parameters
NameData TypeMax Length (Bytes)
@TransNumberint4
SQL Script
create procedure [dbo].[BAEImisTransGetAllByTransNumber] @TransNumber as
int
AS
    SELECT * FROM Trans
    WHERE TRANS_NUMBER = @TransNumber;

GO
Uses
Created 05 April 2012 11:11
Copyright  2012 - All Rights Reserved